﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Database;

namespace ObjectManager
{
    public class HocBong
    {
        private ConnectionDB cnn = null;

        public HocBong()
        {
            cnn = Connection.Connect();
        }

        public DataTable ListAll()
        {
            return cnn.Query("select * from vw_DanhSachHocBong order by NamHoc desc, HocKy desc;");
        }

        public DataTable ListAll(string namhoc, string hocky)
        {
            return cnn.Query("select * from vw_DanhSachHocBong where NamHoc like {0} and HocKy like {1} order by NamHoc desc, HocKy desc;", namhoc, hocky);
        }
    }
}
